﻿
  CREATE TABLE "INTEX"."ICC_EKPOS"
   (    "EKPAID"  NUMBER(9,0),
        "EKPMANDANT" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPAUFKRS" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPAUFLFD" VARCHAR2(6 CHAR) NOT NULL ENABLE,
        "EKPAUFPOS" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPQTYLOCKED" NUMBER(9,0),
        "EKPQTYFREE" NUMBER(9,0),
        "EKPAENDST" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPAENZL" NUMBER(5,0) NOT NULL ENABLE,
        "EKPAENB" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPAEND" NUMBER(9,0) NOT NULL ENABLE,
        "EKPNEUB" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPNEUD" NUMBER(9,0) NOT NULL ENABLE,
        "EKPAUFGRP" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPAUFART" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPARTGR" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPKUNDNR" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPWERK" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPABT" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPWAKZ" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPART" RAW(20),
        "EKPVAR" RAW(3),
        "EKPFARBE" RAW(10),
        "EKPDESS" VARCHAR2(10 CHAR),
        "EKPCOL" VARCHAR2(10 CHAR),
        "EKPBESCH" VARCHAR2(10 CHAR),
        "EKPZUSTAND" VARCHAR2(4 CHAR),
        "EKPGROE" VARCHAR2(7 CHAR),
        "EKPSCHLIGR" VARCHAR2(5 CHAR),
        "EKPSCHLINR" VARCHAR2(15 CHAR),
        "EKPLSART" VARCHAR2(20 CHAR) NOT NULL ENABLE,
        "EKPLSVAR" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPLSFB" VARCHAR2(10 CHAR) NOT NULL ENABLE,
        "EKPLSDESS" VARCHAR2(10 CHAR) NOT NULL ENABLE,
        "EKPLSCOL" VARCHAR2(10 CHAR) NOT NULL ENABLE,
        "EKPLSBE" VARCHAR2(10 CHAR) NOT NULL ENABLE,
        "EKPLSZUSTAND" VARCHAR2(4 CHAR) NOT NULL ENABLE,
        "EKPLSGROE" VARCHAR2(7 CHAR) NOT NULL ENABLE,
        "EKPLSGRPBEZ" VARCHAR2(20 CHAR) NOT NULL ENABLE,
        "EKPLSARTBEZ" VARCHAR2(40 CHAR) NOT NULL ENABLE,
        "EKPSTKLGV" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSTKLGB" NUMBER(9,0) NOT NULL ENABLE,
        "EKPPRKZ" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPPRUEF" VARCHAR2(4 CHAR) NOT NULL ENABLE,
        "EKPMATKOMPDR" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPPARTIE" VARCHAR2(7 CHAR) NOT NULL ENABLE,
        "EKPSPUL" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSPULG" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSPULM" NUMBER(9,0) NOT NULL ENABLE,
        "EKPVPEINH" VARCHAR2(4 CHAR) NOT NULL ENABLE,
        "EKPAM" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPZUSAM" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPHUELSE" VARCHAR2(6 CHAR) NOT NULL ENABLE,
        "EKPKF" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPFDRES" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPWI" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPANZTKB" NUMBER(4,0) NOT NULL ENABLE,
        "EKPLOSGR" NUMBER(4,0) NOT NULL ENABLE,
        "EKPWIRKGEW" NUMBER(9,0) NOT NULL ENABLE,
        "EKPVKUNDNR" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPVWERK" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPVABT" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPVART" RAW(20),
        "EKPVVAR" RAW(3),
        "EKPVFARBE" RAW(10),
        "EKPEKUNDNR" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPEWERK" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPEABT" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPEART" VARCHAR2(20 CHAR),
        "EKPEVAR" VARCHAR2(3 CHAR),
        "EKPEFARBE" VARCHAR2(10 CHAR),
        "EKPEDESS" VARCHAR2(10 CHAR),
        "EKPECOL" VARCHAR2(10 CHAR),
        "EKPEBESCH" VARCHAR2(10 CHAR),
        "EKPEZUSTAND" VARCHAR2(4 CHAR),
        "EKPEGROE" VARCHAR2(7 CHAR),
        "EKPMINLIME" NUMBER(9,0) NOT NULL ENABLE,
        "EKPMINLISP" NUMBER(9,0) NOT NULL ENABLE,
        "EKPMEEH" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPMEEHGRP" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPMEEHFKT" VARCHAR2(12 CHAR) NOT NULL ENABLE,
        "EKPME1" NUMBER(9,0) NOT NULL ENABLE,
        "EKPME2" NUMBER(9,0) NOT NULL ENABLE,
        "EKPME3" NUMBER(9,0) NOT NULL ENABLE,
        "EKPME4" NUMBER(9,0) NOT NULL ENABLE,
        "EKPME5" NUMBER(9,0) NOT NULL ENABLE,
        "EKPME6" NUMBER(9,0) NOT NULL ENABLE,
        "EKPME7" NUMBER(9,0) NOT NULL ENABLE,
        "EKPME8" NUMBER(9,0) NOT NULL ENABLE,
        "EKPME9" NUMBER(9,0) NOT NULL ENABLE,
        "EKPMEO" NUMBER(9,0) NOT NULL ENABLE,
        "EKPMEU" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSMENGE" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWE1" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWE2" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWE3" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWE4" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWE5" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWE6" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWE7" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWE8" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWE9" NUMBER(9,0) NOT NULL ENABLE,
        "EKPBDAT" NUMBER(9,0) NOT NULL ENABLE,
        "EKPLTERM" NUMBER(9,0) NOT NULL ENABLE,
        "EKPFIX" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPLDAT" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPDRUDAT" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWVTERM" NUMBER(9,0) NOT NULL ENABLE,
        "EKPWUTERM" NUMBER(9,0) NOT NULL ENABLE,
        "EKPVEINDAT" NUMBER(9,0) NOT NULL ENABLE,
        "EKPVEINDALT" NUMBER(9,0) NOT NULL ENABLE,
        "EKPLTERMBE" NUMBER(9,0) NOT NULL ENABLE,
        "EKPLTERMKZ" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPVTERMIN" NUMBER(9,0) NOT NULL ENABLE,
        "EKPVTERMEIN" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPDATVON" NUMBER(9,0) NOT NULL ENABLE,
        "EKPBEDAT" NUMBER(9,0) NOT NULL ENABLE,
        "EKPTERMTAB" VARCHAR2(4 CHAR) NOT NULL ENABLE,
        "EKPTERMIND" NUMBER(4,0) NOT NULL ENABLE,
        "EKPSOLLDAT1" NUMBER(9,0) NOT NULL ENABLE,
        "EKPISTDAT1" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSOLLDAT2" NUMBER(9,0) NOT NULL ENABLE,
        "EKPISTDAT2" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSOLLDAT3" NUMBER(9,0) NOT NULL ENABLE,
        "EKPISTDAT3" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSOLLDAT4" NUMBER(9,0) NOT NULL ENABLE,
        "EKPISTDAT4" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSOLLDAT5" NUMBER(9,0) NOT NULL ENABLE,
        "EKPISTDAT5" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSOLLDAT6" NUMBER(9,0) NOT NULL ENABLE,
        "EKPISTDAT6" NUMBER(9,0) NOT NULL ENABLE,
        "EKPLRUECK" NUMBER(4,0) NOT NULL ENABLE,
        "EKPPRME" VARCHAR2(10 CHAR) NOT NULL ENABLE,
        "EKPPREH" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPPREHGRP" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPPREHFKT" VARCHAR2(12 CHAR) NOT NULL ENABLE,
        "EKPPRDR" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPPREISKZ" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPPREISLST" VARCHAR2(5 CHAR) NOT NULL ENABLE,
        "EKPRABATTKZ" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPRABATT" NUMBER(9,0) NOT NULL ENABLE,
        "EKPRABART1" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPRABPROZ1" NUMBER(4,0) NOT NULL ENABLE,
        "EKPRABWERT1" NUMBER(9,0) NOT NULL ENABLE,
        "EKPRABART2" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPRABPROZ2" NUMBER(4,0) NOT NULL ENABLE,
        "EKPRABWERT2" NUMBER(9,0) NOT NULL ENABLE,
        "EKPRABART3" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPRABPROZ3" NUMBER(4,0) NOT NULL ENABLE,
        "EKPRABWERT3" NUMBER(9,0) NOT NULL ENABLE,
        "EKPRABART4" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPRABPROZ4" NUMBER(4,0) NOT NULL ENABLE,
        "EKPRABWERT4" NUMBER(9,0) NOT NULL ENABLE,
        "EKPRABART5" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPRABPROZ5" NUMBER(4,0) NOT NULL ENABLE,
        "EKPRABWERT5" NUMBER(9,0) NOT NULL ENABLE,
        "EKPZUABWERT" NUMBER(9,0) NOT NULL ENABLE,
        "EKPFIXBONP" NUMBER(4,0) NOT NULL ENABLE,
        "EKPFIXBONA" NUMBER(9,0) NOT NULL ENABLE,
        "EKPKALBONP" NUMBER(4,0) NOT NULL ENABLE,
        "EKPKALBONA" NUMBER(9,0) NOT NULL ENABLE,
        "EKPCOUPON" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPKOKRS" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPKOLFD" VARCHAR2(6 CHAR) NOT NULL ENABLE,
        "EKPKOPOS" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPSTA" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPSTAKZ" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPMAHNKZ" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPMAHNKZA" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPMAHNDAT" NUMBER(9,0) NOT NULL ENABLE,
        "EKPKTOKL4" VARCHAR2(6 CHAR) NOT NULL ENABLE,
        "EKPKSTKRS" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPKST" VARCHAR2(4 CHAR) NOT NULL ENABLE,
        "EKPBUDGET" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPINVAUF" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPFAUFTYP" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPFAUFKRS" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPFAUFLFD" VARCHAR2(6 CHAR) NOT NULL ENABLE,
        "EKPFAUFPOS" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPANRKR" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPALFDNR" VARCHAR2(6 CHAR) NOT NULL ENABLE,
        "EKPWAEHRSL" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPKURS" NUMBER(9,0) NOT NULL ENABLE,
        "EKPBETRAG" NUMBER(4,0) NOT NULL ENABLE,
        "EKPHWAEHRSL" VARCHAR2(3 CHAR) NOT NULL ENABLE,
        "EKPHEUROKURS" NUMBER(9,0) NOT NULL ENABLE,
        "EKPHEUROKURSVK" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPFEUROKURS" NUMBER(9,0) NOT NULL ENABLE,
        "EKPFEUROKURSVK" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPTERMNR" NUMBER(9,0) NOT NULL ENABLE,
        "EKPFAELLIG" NUMBER(9,0) NOT NULL ENABLE,
        "EKPSICHER" VARCHAR2(1 CHAR) NOT NULL ENABLE,
        "EKPSICHP" NUMBER(4,0) NOT NULL ENABLE,
        "EKPAKKRED" VARCHAR2(15 CHAR) NOT NULL ENABLE,
        "EKPUDATUM" NUMBER(9,0) NOT NULL ENABLE,
        "EKPUAENZL" NUMBER(4,0) NOT NULL ENABLE,
        "EKPUAENB" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPLIEFNR" VARCHAR2(8 CHAR) NOT NULL ENABLE,
        "EKPKONDSL" VARCHAR2(4 CHAR) NOT NULL ENABLE,
        "EKPLO" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPLB" VARCHAR2(2 CHAR) NOT NULL ENABLE,
        "EKPFILLER14" VARCHAR2(72 CHAR) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 917504 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA"

GO
